home *** CD-ROM | disk | FTP | other *** search
/ PC Answers 2003 September / PC Answers September 2003.iso / Software / trial / MonitorIT 5.2.06 / monitorit_fullsetup.exe / data1.cab / Database / CreateWMIConfigurationTable.sql < prev    next >
Encoding:
Text (UTF-16)  |  2003-06-24  |  986 b   |  18 lines
  1. CREATE TABLE [dbo].[WMIConfiguration] (
  2.     [ID] [int] IDENTITY (1, 1) NOT NULL ,
  3.     [ComputerID] [int] NULL ,
  4.     [ObjectType] [nvarchar] (255) NULL ,
  5.     [Configuration] [ntext] NULL ,
  6.     [UpdateDT] [datetime] NULL 
  7. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  8. GO
  9.  
  10. ALTER TABLE [dbo].[WMIConfiguration] WITH NOCHECK ADD 
  11.     CONSTRAINT [DF__Temporary__Compu__6DCC4D03] DEFAULT (0) FOR [ComputerID],
  12.     CONSTRAINT [aaaaaWMIConfiguration_PK] PRIMARY KEY  NONCLUSTERED 
  13.     (
  14.         [ID]
  15.     )  ON [PRIMARY] 
  16. GO
  17.  
  18.